﻿CREATE TABLE [dbo].[yaf_Forum]
(
[ForumID] [int] NOT NULL IDENTITY(1, 1),
[CategoryID] [int] NOT NULL,
[ParentID] [int] NULL,
[Name] [nvarchar] (128) COLLATE Cyrillic_General_BIN NOT NULL,
[Description] [nvarchar] (255) COLLATE Cyrillic_General_BIN NOT NULL,
[SortOrder] [smallint] NOT NULL,
[LastPosted] [datetime] NULL,
[LastTopicID] [int] NULL,
[LastMessageID] [int] NULL,
[LastUserID] [int] NULL,
[LastUserName] [nvarchar] (50) COLLATE Cyrillic_General_BIN NULL,
[NumTopics] [int] NOT NULL,
[NumPosts] [int] NOT NULL,
[RemoteURL] [nvarchar] (100) COLLATE Cyrillic_General_BIN NULL,
[Flags] [int] NOT NULL,
[ThemeURL] [nvarchar] (50) COLLATE Cyrillic_General_BIN NULL
) ON [PRIMARY]


